This analysis utilizes data from the Parvo ICU End of Shift Report submitted at the end of each shift. It has not been cross-validated against independent (and official) data sources like PetPoint of MyVolunteerPage, and therefore might contain some erroneous data points.

Using data submitted at the end of shifts via the Parvo ICU End of Shift Report, this analysis explores from the trends and patterns in the Parvo ICU over multiple years. Data spans from 2013-06-10 to 2016-03-27 and represents 1927 total observations (e.g. End of Shift submissions).

Volunteers

First, we’ll take a look at the volunteers and staff who were listed as a response to the Shift Staff/Volunteers question on the report. Responses have been modified to fix misspellings and standardize the format.

Responses lists names as a comma separated list, like the one below. The method of parsing names is fairly indiscreet, and identified a total of 102 unique names across all submissions. For the sake of simplicity, only names appearing 10 or more times have been counted. By applying this filter, the number of names counted was reduced to 57.

Additional complications arose from volunteers sharing the same first name. Sometimes submissions will specify which volunteer was present by including their last initial, but often this information is omitted. Therefore, there is a great deal of cross over among a few volunteers with common names, but unfortunatly this is unavoidable.

In cases where a volunteer/staff was listed as training a new volunteer (e.g. Katie training Hunter), both the trainer and trainee have been counted.

Volunteer, Volunteer, …
Volunteer, Trainer training Trainee

To begin, here’s a table of the top 25 volunteers, sorted by the number of shifts for which they’ve been present:

Volunteer n
Katie 524
Emily 253
Stasha 214
Emily M 172
Amy 145
Sara 141
Nipuni 135
Nicole 131
Hunter 128
Kumiko 107
Shelby 99
Sara C 96
Amanda 94
Michael 93
Peggy 91
Shanti 89
Keri 86
Michaela 85
Martha 84
Breanne 83
Will 76
Grace 68
Melissa 68
Erica 66
Genevieve 61

Heatmaps

Who volunteers together

Below is a correlation matrix represented as a heatmap. The values (colors of the blocks) the correlation co-efficient of the number of shifts worked per week by using the pearson method. Higher values represent an increased likelihood that those two volunteers volunteered during the same week.

The numerical value is probably of little practical signifigance, but the general clustering (represented by “chunks” of similar colors, or by the dendograms on either side of the plot) do help to highlight different clusters of volunteers.

Who volunteers by day of the week and AM/PM

Next, we’ll look at another heatmap. This time, however, the numerical values are indicative of the number of shifts that each volunteer has been present for at each time of the day/week.

This figure is colored relative to each volunteer (i.e. by row), so it highlights what days/time each volunteer prefers. The most useful conclusion we may derive here is the noticable lack of crossover between AM and PM volunteers.


Violin/Boxplots

Engagement Over Time

This figure demonstrates the patterns of shifts by each volunteer (with more than 10 shifts total) over the duration of thier time as a Parvo volunteer/staff

Each point represents one shift (colored by how long the shift lasted). Compared to other volunteer oppurtunites at Austin Pets Alive!, Parvo actually has a very high reternion rate, especially among those who have been here for over a year.

Monthly Engagement

Another way to conceptualize this might be to look at the number of

Rolling Hours by days since start

# How About The Dogs?

First, we’ll run an unadjusted linear model based on the number of dogs at each level that are in the ICU

It’s difficult to extrapolate the seasonal trends based on two springs, but if we assume that this sinusoidal pattern were to continue, we should expect a huge peak this summer, since March is only the beginning of the upswing for Parvo season.

But obviously, there’s a whole lot of variance from the mean

Inventory/Supplies

Create a data.frame of all the Inventory requests

Tracking the request over time

## Source: local data frame [59 x 2]
## 
##                  Supply     n
##                   (chr) (int)
## 1                Turkey   319
## 2        Chicken Sticks   266
## 3   Variety Canned food   234
## 4             Baby Food   221
## 5                Bleach   158
## 6            Famotidine   156
## 7  Cefazolin/Ampicillin   146
## 8               Anzemet   141
## 9                   LRS   121
## 10         3cc Syringes   117
## ..                  ...   ...

A pretty uneventful correlation matrix visualized as a heatmap

r.squared adj.r.squared sigma statistic p.value df
0.879597 0.8792209 56.06913 2338.958 0 6
--- LICENSE ---

Copyright (C) 2016 Hunter Ratliff

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

In the spirit of Reproducible Research, below is the information About the R Session at the time it was compiled:

devtools::session_info()
##  setting  value                       
##  version  R version 3.2.3 (2015-12-10)
##  system   x86_64, darwin14.5.0        
##  ui       X11                         
##  language (EN)                        
##  collate  en_US.UTF-8                 
##  tz       America/Chicago             
##  date     2016-04-04                  
## 
##  package      * version date       source                            
##  assertthat     0.1     2013-12-06 CRAN (R 3.2.0)                    
##  base64enc      0.1-3   2015-07-28 CRAN (R 3.2.0)                    
##  broom        * 0.4.0   2015-11-30 CRAN (R 3.2.3)                    
##  colorspace     1.2-6   2015-03-11 CRAN (R 3.2.0)                    
##  d3heatmap      0.6.1   2015-12-03 Github (rstudio/d3heatmap@3145f89)
##  DBI            0.3.1   2014-09-24 CRAN (R 3.2.0)                    
##  devtools       1.10.0  2016-01-23 CRAN (R 3.2.3)                    
##  digest         0.6.8   2014-12-31 CRAN (R 3.2.0)                    
##  dplyr        * 0.4.3   2015-09-01 CRAN (R 3.2.0)                    
##  evaluate       0.8     2015-09-18 CRAN (R 3.2.0)                    
##  formatR        1.2.1   2015-09-18 CRAN (R 3.2.0)                    
##  ggplot2      * 2.1.0   2016-03-24 Github (hadley/ggplot2@59c503b)   
##  ggrepel      * 0.4     2016-01-13 Github (slowkow/ggrepel@1e13fed)  
##  ggthemes     * 3.0.1   2016-01-10 CRAN (R 3.2.3)                    
##  gridExtra      2.0.0   2015-07-14 CRAN (R 3.2.0)                    
##  gtable         0.1.2   2012-12-05 CRAN (R 3.2.0)                    
##  highr          0.5.1   2015-09-18 CRAN (R 3.2.0)                    
##  htmltools      0.3     2015-12-29 CRAN (R 3.2.3)                    
##  htmlwidgets    0.5     2015-06-21 CRAN (R 3.2.0)                    
##  jsonlite       0.9.19  2015-11-28 CRAN (R 3.2.2)                    
##  knitr          1.12.3  2016-01-22 CRAN (R 3.2.3)                    
##  labeling       0.3     2014-08-23 CRAN (R 3.2.0)                    
##  lattice        0.20-33 2015-07-14 CRAN (R 3.2.3)                    
##  lazyeval       0.1.10  2015-01-02 CRAN (R 3.2.0)                    
##  lubridate    * 1.5.0   2015-12-03 CRAN (R 3.2.3)                    
##  magrittr       1.5     2014-11-22 CRAN (R 3.2.0)                    
##  Matrix         1.2-3   2015-11-28 CRAN (R 3.2.3)                    
##  memoise        1.0.0   2016-01-29 CRAN (R 3.2.3)                    
##  mgcv           1.8-10  2015-12-12 CRAN (R 3.2.3)                    
##  mnormt         1.5-3   2015-05-25 CRAN (R 3.2.0)                    
##  munsell        0.4.2   2013-07-11 CRAN (R 3.2.0)                    
##  nlme           3.1-122 2015-08-19 CRAN (R 3.2.3)                    
##  plyr           1.8.3   2015-06-12 CRAN (R 3.2.0)                    
##  png            0.1-7   2013-12-03 CRAN (R 3.2.0)                    
##  psych          1.5.8   2015-08-30 CRAN (R 3.2.0)                    
##  R6             2.1.1   2015-08-19 CRAN (R 3.2.0)                    
##  RColorBrewer   1.1-2   2014-12-07 CRAN (R 3.2.0)                    
##  Rcpp           0.12.2  2015-11-15 CRAN (R 3.2.2)                    
##  reshape2       1.4.1   2014-12-06 CRAN (R 3.2.0)                    
##  rmarkdown      0.9.1   2015-12-31 CRAN (R 3.2.3)                    
##  scales       * 0.3.0   2015-08-25 CRAN (R 3.2.0)                    
##  stringi        1.0-1   2015-10-22 CRAN (R 3.2.0)                    
##  stringr        1.0.0   2015-04-30 CRAN (R 3.2.0)                    
##  tidyr        * 0.4.1   2016-02-05 CRAN (R 3.2.3)                    
##  yaml           2.1.13  2014-06-12 CRAN (R 3.2.0)